SAS Real-Time Decision Manager supplies a LoadTreatments utility that enables you to upload your treatment data to a database. However, this utility might not successfully load treatment data into an Oracle database.

This problem occurs because the name of one of the expected columns, ALLOW_MULTIPLE_LIST_VALUES_FLAG, exceeds the length limit for column names in Oracle. You cannot create the necessary underlying table in Oracle to accept the uploaded treatments. If you create the table with that column omitted and then attempt to run the load treatments command, you receive the following errors:

2014-07-14 11:15:42: Unable to read custom detail table XXXXXX.
2014-07-14 11:15:42: Unable to execute query: SQL passthru expression contained these errors: 
ERROR: The following columns were not found in the contributing tables: ALLOW_MULTIPLE_LIST_VALUES_FLAG.

To work around this issue, create the table with the column name ALLOW_MULTIPLE_LIST_VALUES_FLG.

Operating System and Release Information